New:

CREATE DATABASE highscores;
USE highscores;
CREATE TABLE pvphighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL);
CREATE TABLE mobhighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL);
CREATE TABLE minehighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
coal INT( 11 ) NOT NULL DEFAULT 0,
iron INT( 11 ) NOT NULL DEFAULT 0,
redstone INT( 11 ) NOT NULL DEFAULT 0,
lapis INT( 11 ) NOT NULL DEFAULT 0,
gold INT( 11 ) NOT NULL DEFAULT 0,
obby INT( 11 ) NOT NULL DEFAULT 0,
diamond INT( 11 ) NOT NULL DEFAULT 0);


Existing v0.1:

USE highscores;
RENAME TABLE highscores TO pvphighscores;
CREATE TABLE mobhighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL,);
CREATE TABLE minehighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
coal INT( 11 ) NOT NULL DEFAULT 0,
iron INT( 11 ) NOT NULL DEFAULT 0,
redstone INT( 11 ) NOT NULL DEFAULT 0,
lapis INT( 11 ) NOT NULL DEFAULT 0,
gold INT( 11 ) NOT NULL DEFAULT 0,
obby INT( 11 ) NOT NULL DEFAULT 0,
diamond INT( 11 ) NOT NULL DEFAULT 0);


Existing v0.2:

USE highscores;
CREATE TABLE minehighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
coal INT( 11 ) NOT NULL DEFAULT 0,
iron INT( 11 ) NOT NULL DEFAULT 0,
redstone INT( 11 ) NOT NULL DEFAULT 0,
lapis INT( 11 ) NOT NULL DEFAULT 0,
gold INT( 11 ) NOT NULL DEFAULT 0,
obby INT( 11 ) NOT NULL DEFAULT 0,
diamond INT( 11 ) NOT NULL DEFAULT 0);

